package com.cmc.cloud.cmclink.doc.mapper;

import com.cmc.cloud.cmclink.doc.vo.blnocntrrecordationvo.BlnoCntrRecordationPageReqVO;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.cmes.framework.mybatis.core.mapper.BaseMapperX;
import com.cmc.cloud.cmclink.doc.entity.BlnoCntrRecordationDO;
import org.apache.ibatis.annotations.Mapper;

/**
 * 提单箱况备案 Mapper
 *
 * @author 集运管理员
 */
@Mapper
public interface BlnoCntrRecordationMapper extends BaseMapperX<BlnoCntrRecordationDO> {
    /**
     * 提单箱况备案
     *
     * @param page
     * @param reqVo
     * @return
     */
    IPage<BlnoCntrRecordationDO> selectPageList(IPage<BlnoCntrRecordationDO> page, @Param("reqVo") BlnoCntrRecordationPageReqVO reqVo);

    /**
     * 通过订舱号物理删除 箱况备案
     * @param bookingNo
     */
    @Delete(" delete from doc_blno_cntr_recordation where booking_no =#{bookingNo}")
    void deleteByBlno(@Param("bookingNo") String bookingNo);

}
